﻿-- 此脚本作为平台预制数据参考使用。
-- 严禁将此脚本直接或修改后在数据库中执行,如由上述行为引发问题,概不支持。


-- 经典示例 涉及的iuap平台预制数据和示例预制数据 start -------------------------------------------------------
-- ----------------------------
-- Records of WB_AREAS
-- ----------------------------
INSERT INTO WB_AREAS (ID, AREA_CODE, AREA_NAME, ISENABLE, SORT, TENANT_ID, AREA_NAME2, AREA_NAME3, AREA_NAME4, AREA_NAME5, AREA_NAME6) VALUES ('super646966f7aa5d4b338b9897afc1629df6', '011111', '开发示例', 'Y', '9', 'super', 'example', '開發示例', NULL, NULL, NULL);

-- IUAP_MSGTEMPLATE 流程消息预制--
INSERT INTO IUAP_MSGTEMPLATE (ID, CODE, NAME, TEMPGROUP, TYPE, DATA, TITLE, TENANTID, SYSID, ISSYSTEM, CHANNEL, LANGUAGE, CATEGORYID, NOTE, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super11', 'DEFAULTTASKTEMPLATE', '流程消息默认模板', NULL, 'TRUE', '点击消息会打开单据', '用户 [task.creator] 的 [BUS_BILL_TYPE] ，单号是 [task.billcode] ，用户 [SENDMAN] [BUS_TASK_TYPE]', 'super', NULL,'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Records of WB_APP_GROUPS
-- ----------------------------
INSERT INTO WB_APP_GROUPS (ID, NAME, APP_GROUPINDEX, AREA_ID, TENANT_ID, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super6c173e474f3742a1b70960f4e1cca4df', 'React', '2', 'super646966f7aa5d4b338b9897afc1629df6', 'super', 'React', 'React', NULL, NULL, NULL);

-- ----------------------------
-- Records of WB_APP_APPS
-- ----------------------------
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('super00e601475c6c471aa2cd2250bbcc7ff1', '一主一子', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/masterdetail-one#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'masterdetail-one', NULL, 'super', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:45:01', NULL, 'masterdetail-one', '一主一子', NULL, NULL, NULL);
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('super1e1573e4a3574e6bb5e8be60f164a6ee', '弹框编辑', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-popup-edit#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-popupedit', NULL, 'super', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:48:19', NULL, 'singletable-popupedit', '彈框編輯', NULL, NULL, NULL);
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('super2928822db89c433184c04957b6f1fe6f', '一主多子', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/masterdetail-many#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'masterdetail-many', NULL, 'super', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:43:59', NULL, 'masterdetail-many', '一主多子', NULL, NULL, NULL);
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('super9b03021ef646490499af7bfd2e42a1bc', '左树右表', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/tree#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'tree', NULL, 'super', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:50:59', NULL, 'tree', '左樹右表', NULL, NULL, NULL);
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('supera68b611de88d40b7869fbdec63fa15e9', '行内编辑', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-inline-edit#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-inlineEdit', NULL, 'super', 'url', '2', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:47:08', NULL, 'singletable-inlineEdit', '行內編輯', NULL, NULL, NULL);
INSERT INTO WB_APP_APPS (ID, APP_NAME, APP_INDEX, GROUP_ID, DOMAIN_ID, URL, APP_CHINESE, APP_DESC, APP_ICON, APP_GROUPCODE, APP_CODE, DYNA_URL, TENANT_ID, URLTYPE, VERSION, SYSTEM, LABEL, SHOWWAY, CREATOR, REVISER, CREATE_DATE, MODIFY_DATE, APP_NAME2, APP_NAME3, APP_NAME4, APP_NAME5, APP_NAME6) VALUES ('superf3efaf3a6caa443baa52ba762345a56e', '单表查询', '', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/singletable-query#/', NULL, NULL, 'grey iconfont icon-appicon', NULL, 'singletable-query', NULL, 'super', 'url', '1', 'wbalone', NULL, 'apparea', 'U001', NULL, '2018-12-06 20:49:20.797', NULL, 'singletable-query', '單表查詢', NULL, NULL, NULL);

-- ----------------------------
-- Records of WB_LABEL_RELATION
-- ----------------------------
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('super1924e837be834dfe8dff8747ac7b97b6', 'buisource', 'singletable-query', '2018-12-06 20:49:20.797', 'super', NULL, NULL, 'superf3efaf3a6caa443baa52ba762345a56e', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('super253bd6db452c4ce4aa2bd7ca553d456c', 'buisource', 'singletable-grouping', '2018-12-06 20:46:10.600', 'super', NULL, NULL, 'super1e64fafeb734479aba2509827dfe06e8', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('super3ec6d1976c5e4ba8aafc481836705cc5', 'buisource', 'singletable-viewtemplate', '2018-12-06 20:50:08.277', 'super', NULL, NULL, 'superf86f96e553e74a33a06c5ac69d4e9c45', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('super430afbb6325a4583a5a71920baa5be1a', 'buisource', 'tree', '2018-12-06 20:50:59.687', 'super', NULL, NULL, 'super9b03021ef646490499af7bfd2e42a1bc', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('superbc664a4e20a641af988c5322dd43aed8', 'buisource', 'singletable-inlineEdit', '2018-12-06 20:47:08.727', 'super', NULL, NULL, 'supera68b611de88d40b7869fbdec63fa15e9', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('superd4c276b8a38842899f0d6785261d7633', 'buisource', 'masterdetail-one', '2018-12-06 20:45:01.997', 'super', NULL, NULL, 'super00e601475c6c471aa2cd2250bbcc7ff1', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('supere406e4eac7ec41c88b09418d24608b8c', 'buisource', 'singletable-popupedit', '2018-12-06 20:48:19.413', 'super', NULL, NULL, 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'app');
INSERT INTO WB_LABEL_RELATION (ID, LABELCODE, SOURCECODE, CREATE_DATE, TENANT_ID, SYSTEM, LABLEID, SOURCEID, TYPE) VALUES ('superf3f02e97a7314e1293c3c22cc2eb0e9c', 'buisource', 'masterdetail-many', '2018-12-06 20:48:19.413', 'super', NULL, NULL, 'super2928822db89c433184c04957b6f1fe6f', 'app');

-- ----------------------------
-- Records of IEOP_FUNCTION
-- ----------------------------
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('super00e601475c6c471aa2cd2250bbcc7ff1', '一主一子', 'masterdetail-one', 'N', '/iuap-pap-demo-be/purchase_order,/iuap-pap-demo-be/purchase_order_detail', 'Y', 'Y', null, 'N', 'ROOT', 'super', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/masterdetail-one#/', 'masterdetail-one', '一主一子', null, null, null);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('super2928822db89c433184c04957b6f1fe6f', '一主多子', 'masterdetail-many', 'N', '/iuap-pap-demo-be/passenger,/iuap-pap-demo-be/emergency_contact,/iuap-pap-demo-be/traveling_information', 'Y', 'Y', null, 'N', 'ROOT', 'super', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/masterdetail-many#/', 'masterdetail-many', '一主多子', null, null, null);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('super9b03021ef646490499af7bfd2e42a1bc', '左树右表', 'tree', 'N', '/iuap-pap-demo-be/tree_demo,/iuap-pap-demo-be/table_demo', 'Y', 'Y', null, 'N', 'ROOT', 'super', 'wbalone', 'Y', null, '/iuap-pap-demo-fe/tree#/', 'tree', '左樹右表', null, null, null);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('superf3efaf3a6caa443baa52ba762345a56e', '单表查询', 'singletable-query', 'N', '/iuap-pap-demo-be/query_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'super', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-query#/', 'singletable-query', '單表查詢', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('super1e1573e4a3574e6bb5e8be60f164a6ee', '弹框编辑', 'singletable-popupedit', 'N', '/iuap-pap-demo-be/popup_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'super', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-popup-edit#/', 'singletable-popupedit', '彈框編輯', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION (ID, FUNC_NAME, FUNC_CODE, FUNC_TYPE, FUNC_URL, ISCONTROL, ISACTIVE, CREATE_DATE, ISLEAF, PARENT_ID, TENANT_ID, SYS_ID, ENABLEACTION, CREATOR, MENU_URL, FUNC_NAME2, FUNC_NAME3, FUNC_NAME4, FUNC_NAME5, FUNC_NAME6) VALUES ('supera68b611de88d40b7869fbdec63fa15e9', '行内编辑', 'singletable-inlineEdit', 'N', '/iuap-pap-demo-be/inline_allowances', 'Y', 'Y', NULL, 'N', 'ROOT', 'super', 'wbalone', 'Y', NULL, '/iuap-pap-demo-fe/singletable-inline-edit#/', 'singletable-inlineEdit', '行內編輯', NULL, NULL, NULL);

-- ----------------------------
-- Records of WB_APP_MENU
-- ----------------------------
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('superd2f8a0b7751a453d9e8d7e3cc3aceb62', 'example', 'grey iconfont icon-appicon', 'Y', 'Y', 'Y', 'superM0000000000001', NULL, 'null', '1', '2018-12-06 20:52:19.687', '开发示例', 'super', '1', NULL, NULL, NULL, 'curnpage', 'walsin', '開發示例', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('supere238812395b647969d77be13757abb1e', 'React', ' iconfont icon-appicon ', 'Y', 'Y', 'Y', 'superd2f8a0b7751a453d9e8d7e3cc3aceb62', NULL, 'null', '1', '2018-12-12 13:28:08.483', 'React', 'super', '0', 'common', NULL, NULL, 'curnpage', 'React', 'React', NULL, NULL, NULL);

INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super22ee86794c0b4dc7b26779a7b0135a12', 'singletable-inlineEdit', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'singletable-inlineEdit', '2', '2018-12-06 20:53:33.577', 'A2单表行内编辑', 'super', '1', NULL, NULL, NULL, 'curnpage', 'singletable-inlineEdit', 'A2單表行內編輯', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super2d2e26ba95f542cf9adb7811168c5377', 'tree', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'tree', '4', '2018-12-06 20:54:51.367', 'B1左树右表', 'super', '1', NULL, NULL, NULL, 'curnpage', 'tree', 'B1左樹右表', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super5355a23b52f44b219cff084e28fa9dc9', 'singletable-query', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'singletable-query', '1', '2018-12-06 20:52:59.180', 'A1单表查询', 'super', '1', NULL, NULL, NULL, 'curnpage', 'singletable-query', 'A1單表查詢', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super592593f078e54639a648b8e2f71b98bd', 'masterdetail-many', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'masterdetail-many', '6', '2018-12-06 20:55:48.663', 'B3一主多子', 'super', '1', NULL, NULL, NULL, 'curnpage', 'masterdetail-many', 'B3一主多子', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('super802be413f3254d49aab0a24b0603c973', 'singletable-popupedit', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'singletable-popupedit', '3', '2018-12-06 20:54:12.340', 'A3单表弹窗编辑', 'super', '2', NULL, NULL, NULL, 'curnpage', 'singletable-popupedit', 'A3單表彈窗編輯', 'null', 'null', 'null');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('superc129091db54f4506987109754f4bdaff', 'masterdetail-one', ' iconfont icon-appicon ', 'Y', 'Y', '', 'supere238812395b647969d77be13757abb1e', NULL, 'masterdetail-one', '5', '2018-12-06 20:55:22.603', 'B2一主一子', 'super', '1', NULL, NULL, NULL, 'curnpage', 'masterdetail-one', 'B2一主一子', 'null', 'null', 'null');

-- ----------------------------
-- Records of IEOP_FUNCTION_ACTIVITY
-- ----------------------------
-- INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super06fd431b824a4fe3b8ddc057ef8cf314', '详情', 'check', '/purchase_order/getAssoVo', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'super', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super1bf819b5fdf8403aabdfb46d902443af', '删除tr', 'delete_tr', '/traveling_information/deleteBatch', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'delete_tr', '刪除tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super1cc2c2b68d6d444f8ab82efee52cf45a', '详情', 'check', '/inline_allowances/list', 'supera68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'super', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super2cb772bd2dea4900bde1c13ef331066b', '新增em', 'add_em', '/emergency_contact/insertSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'add_em', '新增em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super2cd535bf7d494467b5b1c471cdad6a0b', '新增', 'add', '/popup_allowances/insertSelective', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'super', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super2dc6e7dc94b84a3ea984d22546a0140a', '详情', 'check', '/table_demo/list', 'super9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'super', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super326ac364d5274c839d9bc323426e5447', '新增', 'add', '/passenger/insertSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super4b7bcf27758e4fd9808f30baca119985', '修改', 'update', '/purchase_order/updateAssoVo', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'super', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super4e568299dc884405a7e7e9aedf01711c', '删除', 'delete', '/popup_allowances/deleteBatch', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'super', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super571c1124e86049f5b3e2a1fed7d6b8b3', '新增', 'add', '/purchase_order/saveAssoVo', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'super', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super792bef6886b64da691be2e11ee07d285', '修改', 'update', '/table_demo/updateSelective', 'super9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'super', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super8c307c88426b4f18b27c65a64501d746', '新增', 'add', '/inline_allowances/insertSelective', 'supera68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'super', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super8ea4dd3f92184315bf59fc745017039c', '删除em', 'delete_em', '/emergency_contact/deleteBatch', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'delete_em', '刪除em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('super9cb5c7e59e2c44e99f86e0c7232ba742', '新增tr', 'add_tr', '/traveling_information/insertSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'add_tr', '新增tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('supera3471008814b41e5aba077ba310a5c20', '修改tr', 'update_tr', '/traveling_information/updateSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'update_tr', '修改tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('supera393f919ba9640ffac39798109984278', '修改', 'update', '/passenger/updateSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superaa74b7d81f024cfca0038cdd88f4b799', '详情em', 'check_em', '/emergency_contact/list', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'check_em', '詳情em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superadf710afbb884c2ab495098254de49c5', '删除', 'delete', '/purchase_order/deleteBatch', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'Y', NULL, 'wbalone', 'super', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superbeba9692b84f4d6e981d95ea4d35b3ef', '详情', 'check', '/passenger/list', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'check', '詳情', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superbfac5913447d4367bc6d2f5f87de5e4f', '修改', 'update', '/inline_allowances/updateSelective', 'supera68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'super', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superc15008a829d7443aaa3fbbd37e17581c', '新增', 'add', '/table_demo/insertSelective', 'super9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'super', 'add', '新增', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superc30209cdb318415897940e96025b7e7a', '删除', 'delete', '/table_demo/deleteBatch', 'super9b03021ef646490499af7bfd2e42a1bc', 'Y', NULL, 'wbalone', 'super', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superc6c588de675f4400a045fd21a8690c3a', '详情tr', 'check_tr', '/traveling_information/list', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'check_tr', '詳情tr', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superd33ee12e6d3a4b729224e7c26c892cf5', '修改em', 'update_em', '/emergency_contact/updateSelective', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'update_em', '修改em', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superd4cd90dbdec343b499df11f5123ebd01', '删除', 'delete', '/inline_allowances/deleteBatch', 'supera68b611de88d40b7869fbdec63fa15e9', 'Y', NULL, 'wbalone', 'super', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('superd592f92cbc394d9faab809f86492dbd2', '删除', 'delete', '/passenger/deleteBatch', 'super2928822db89c433184c04957b6f1fe6f', 'Y', NULL, 'wbalone', 'super', 'delete', '刪除', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('supere2811e0c075a410e841e1a913f7041d3', '修改', 'update', '/popup_allowances/updateSelective', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'super', 'update', '修改', NULL, NULL, NULL);
INSERT INTO IEOP_FUNCTION_ACTIVITY(ID, ACTIVITY_NAME, ACTIVITY_CODE, ACTIVITY_URL, FUNC_ID, ISACTIVE, CREATE_DATE, SYS_ID, TENANT_ID, ACTIVITY_NAME2, ACTIVITY_NAME3, ACTIVITY_NAME4, ACTIVITY_NAME5, ACTIVITY_NAME6) VALUES ('supere5f8d2697bb543b5bec815110bcdbd49', '详情', 'check', '/popup_allowances/list', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'Y', NULL, 'wbalone', 'super', 'check', '詳情', NULL, NULL, NULL);


-- ----------------------------
-- Records of IEOP_ROLE_PERMISSION
-- ----------------------------
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000100', 'superR001', 'admin', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'masterdetail-one', '1', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000101', 'superR001', 'admin', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'singletable-popupedit', '1', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000102', 'superR001', 'admin', 'super2928822db89c433184c04957b6f1fe6f', 'masterdetail-many', '1', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000103', 'superR001', 'admin', 'super9b03021ef646490499af7bfd2e42a1bc', 'tree', '1', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000104', 'superR001', 'admin', 'supera68b611de88d40b7869fbdec63fa15e9', 'singletable-inlineEdit', '1', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000105', 'superR001', 'admin', 'superf3efaf3a6caa443baa52ba762345a56e', 'singletable-query', '1', 'super', 'wbalone');

INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000200', 'superR001', 'admin', 'super06fd431b824a4fe3b8ddc057ef8cf314', '/PURCHASE_ORDER/getAssoVo', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000201', 'superR001', 'admin', 'super1bf819b5fdf8403aabdfb46d902443af', '/TRAVELING_INFORMATION/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000202', 'superR001', 'admin', 'super1cc2c2b68d6d444f8ab82efee52cf45a', '/ALLOWANCES/list', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000203', 'superR001', 'admin', 'super2cb772bd2dea4900bde1c13ef331066b', '/EMERGENCY_CONTACT/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000204', 'superR001', 'admin', 'super2cd535bf7d494467b5b1c471cdad6a0b', '/ALLOWANCES/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000205', 'superR001', 'admin', 'super2dc6e7dc94b84a3ea984d22546a0140a', '/TABLE_DEMO/list', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000206', 'superR001', 'admin', 'super326ac364d5274c839d9bc323426e5447', '/PASSENGER/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000207', 'superR001', 'admin', 'super4b7bcf27758e4fd9808f30baca119985', '/PURCHASE_ORDER/updateAssoVo', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000208', 'superR001', 'admin', 'super4e568299dc884405a7e7e9aedf01711c', '/ALLOWANCES/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000209', 'superR001', 'admin', 'super571c1124e86049f5b3e2a1fed7d6b8b3', '/PURCHASE_ORDER/saveAssoVo', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000210', 'superR001', 'admin', 'super792bef6886b64da691be2e11ee07d285', '/TABLE_DEMO/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000211', 'superR001', 'admin', 'super8c307c88426b4f18b27c65a64501d746', '/ALLOWANCES/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000212', 'superR001', 'admin', 'super8ea4dd3f92184315bf59fc745017039c', '/EMERGENCY_CONTACT/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000213', 'superR001', 'admin', 'super9cb5c7e59e2c44e99f86e0c7232ba742', '/TRAVELING_INFORMATION/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000214', 'superR001', 'admin', 'supera3471008814b41e5aba077ba310a5c20', '/TRAVELING_INFORMATION/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000215', 'superR001', 'admin', 'supera393f919ba9640ffac39798109984278', '/PASSENGER/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000216', 'superR001', 'admin', 'superaa74b7d81f024cfca0038cdd88f4b799', '/EMERGENCY_CONTACT/list', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000217', 'superR001', 'admin', 'superadf710afbb884c2ab495098254de49c5', '/PURCHASE_ORDER/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000218', 'superR001', 'admin', 'superbeba9692b84f4d6e981d95ea4d35b3ef', '/PASSENGER/list', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000219', 'superR001', 'admin', 'superbfac5913447d4367bc6d2f5f87de5e4f', '/ALLOWANCES/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000220', 'superR001', 'admin', 'superc15008a829d7443aaa3fbbd37e17581c', '/TABLE_DEMO/insertSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000221', 'superR001', 'admin', 'superc30209cdb318415897940e96025b7e7a', '/TABLE_DEMO/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000222', 'superR001', 'admin', 'superc6c588de675f4400a045fd21a8690c3a', '/TRAVELING_INFORMATION/list', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000223', 'superR001', 'admin', 'superd33ee12e6d3a4b729224e7c26c892cf5', '/EMERGENCY_CONTACT/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000224', 'superR001', 'admin', 'superd4cd90dbdec343b499df11f5123ebd01', '/ALLOWANCES/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000225', 'superR001', 'admin', 'superd592f92cbc394d9faab809f86492dbd2', '/PASSENGER/deleteBatch', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000226', 'superR001', 'admin', 'supere2811e0c075a410e841e1a913f7041d3', '/ALLOWANCES/updateSelective', 'action', 'super', 'wbalone');
INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superPERMI00000227', 'superR001', 'admin', 'supere5f8d2697bb543b5bec815110bcdbd49', '/ALLOWANCES/list', 'action', 'super', 'wbalone');

-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super0e7b3e44e881446a93eeee0069d1226d', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super8ea4dd3f92184315bf59fc745017039c', '/EMERGENCY_CONTACT/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super2070ae3add3c4edb83cac2a50e1b68e6', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super1cc2c2b68d6d444f8ab82efee52cf45a', '/ALLOWANCES/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super240744640f11410698101807f34ea63f', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'super9b03021ef646490499af7bfd2e42a1bc', 'tree', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super2410f6f95c834863b4834276403a5189', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superbfac5913447d4367bc6d2f5f87de5e4f', '/ALLOWANCES/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super24a910f93c484d4f81b238e4e983f67d', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super1bf819b5fdf8403aabdfb46d902443af', '/TRAVELING_INFORMATION/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super276d069aff5f44cb9bfc818a1ef83377', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'superAPP00000003', 'index', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super281adb59de0c4567a23760c7252d9ad0', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super4b7bcf27758e4fd9808f30baca119985', '/PURCHASE_ORDER/saveAssoVo', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super30d9a439e5064651b77b79c1b3aa827c', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superadf710afbb884c2ab495098254de49c5', '/PURCHASE_ORDER/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super3464527dd91143978660f574b18da842', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super9b03021ef646490499af7bfd2e42a1bc', 'tree', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super3aa3ad144fcd4d2698480c8d53884ad8', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'supere5f8d2697bb543b5bec815110bcdbd49', '/ALLOWANCES/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super438440b0067340328e2b9c6e3d95a63a', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superc6c588de675f4400a045fd21a8690c3a', '/TRAVELING_INFORMATION/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super450e0b5fc7104cef923aab2f99122427', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super2cb772bd2dea4900bde1c13ef331066b', '/EMERGENCY_CONTACT/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super4aea6a6daa544db39fd27da91c791bab', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superc30209cdb318415897940e96025b7e7a', '/TABLE_DEMO/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super4b99d33c9cda437390d61827a62b8b76', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super326ac364d5274c839d9bc323426e5447', '/PASSENGER/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super4fe0f22053454a0bb00bdc1eaeb45a6b', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super2cd535bf7d494467b5b1c471cdad6a0b', '/ALLOWANCES/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super53e2717b8afc4cca95ae5ed7cff25adb', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'super2928822db89c433184c04957b6f1fe6f', 'masterdetail-many', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super5ec8c02d254142619bf6acf1abe4c198', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super2dc6e7dc94b84a3ea984d22546a0140a', '/TABLE_DEMO/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super5f9f049dc1a6408fa1cee37009890283', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super06fd431b824a4fe3b8ddc057ef8cf314', '/PURCHASE_ORDER/getAssoVo', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super6a622e3652e343949ec8766d063fecb2', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'singletable-popupedit', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super6bfd7c2de95d4bb6821410f5d6657bb7', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'supera393f919ba9640ffac39798109984278', '/PASSENGER/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super6cd2ebd8bbca46838f81fc4a846a184e', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'supera3471008814b41e5aba077ba310a5c20', '/TRAVELING_INFORMATION/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super6f59fa1cbf844d57876b60b158da1839', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super571c1124e86049f5b3e2a1fed7d6b8b3', '/PURCHASE_ORDER/saveAssoVo', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super7affe1e984874f1592444ec54c222070', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superf3efaf3a6caa443baa52ba762345a56e', 'singletable-query', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super7e19538db35146fdac152c5c5a054630', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superc15008a829d7443aaa3fbbd37e17581c', '/TABLE_DEMO/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super866f362580334a559b1fa472365a6e89', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super792bef6886b64da691be2e11ee07d285', '/TABLE_DEMO/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super87cdce80eeb449c1afc1c2b50c16c0d6', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superAPP00000003', 'index', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super8be5f847bc244e7ca2540441dda10df8', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super8c307c88426b4f18b27c65a64501d746', '/ALLOWANCES/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super8ff153601afe49b29426ef7dd64ba613', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super1e1573e4a3574e6bb5e8be60f164a6ee', 'singletable-popupedit', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super930f4b295060484bbaaf095d77ce2d16', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'supera68b611de88d40b7869fbdec63fa15e9', 'singletable-inlineEdit', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super9508eeb373f64fa0bff4eef98a7a41c8', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superd33ee12e6d3a4b729224e7c26c892cf5', '/EMERGENCY_CONTACT/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super9685b16a86404e0a8611c551ecf7df94', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'supere2811e0c075a410e841e1a913f7041d3', '/ALLOWANCES/updateSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super9be8b011bb864e7fbbe2aaac7b65a1d4', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'masterdetail-one', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superc217d16a47fb48e294c68d08b4645b91', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super9cb5c7e59e2c44e99f86e0c7232ba742', '/TRAVELING_INFORMATION/insertSelective', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superc2e0616a17694d8a9cedcda7c06ffbfe', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superd592f92cbc394d9faab809f86492dbd2', '/PASSENGER/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superc7061aaad7a34db5807afa9f26d6fee8', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'super00e601475c6c471aa2cd2250bbcc7ff1', 'masterdetail-one', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superc7e367e5b2234286b568c18e3bf9ec39', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superaa74b7d81f024cfca0038cdd88f4b799', '/EMERGENCY_CONTACT/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superc9ee16c43cd44837a6d06a8d8cf11dc7', 'super567ce9517fec4c6aa76d984695dbe0c4', 'role02', 'superf3efaf3a6caa443baa52ba762345a56e', 'singletable-query', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superdde51e35175b4956ac705345ff15c5e6', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superbeba9692b84f4d6e981d95ea4d35b3ef', '/PASSENGER/list', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superdefa59811a51453f8e91b4f535394bb4', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'superd4cd90dbdec343b499df11f5123ebd01', '/ALLOWANCES/deleteBatch', 'action', 'super', 'wbalone');
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('supere3b4def002df41e883480eb7fe469673', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'supera68b611de88d40b7869fbdec63fa15e9', 'singletable-inlineEdit', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('supere76ea9e39f6247218d1359db9dc704c4', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super2928822db89c433184c04957b6f1fe6f', 'masterdetail-many', '1', 'super', NULL);
-- INSERT INTO IEOP_ROLE_PERMISSION (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('superf65ea7f7c49541219f425a22acc9c3a6', 'super7e0b25ec1f4648e1a0919d996e278d65', 'role01', 'super4e568299dc884405a7e7e9aedf01711c', '/ALLOWANCES/deleteBatch', 'action', 'super', 'wbalone');

-- ----------------------------
-- Records of IEOP_ROLE
-- ----------------------------
-- INSERT INTO IEOP_ROLE (ID, ROLE_NAME, ROLE_CODE, ROLE_TYPE, ISACTIVE, CREATE_DATE, TENANT_ID, LABEL, DTYPE, REMARK, CREATOR, MODIFY_DATE, REVISER, LABEL_NAME, SYS_ID, TS, DR, ROLE_NAME2, ROLE_NAME3, ROLE_NAME4, ROLE_NAME5, ROLE_NAME6, LABEL_NAME2, LABEL_NAME3, LABEL_NAME4, LABEL_NAME5, LABEL_NAME6) VALUES ('super7e0b25ec1f4648e1a0919d996e278d65', '高级业务员', 'role01', 'user', 'Y', '2018-12-06 20:56:58', 'super', 'buisource', 'WBRole', NULL, 'U001', '2018-12-13 15:15:15', 'U001', '业务员', 'wbalone', '1544685315138', '0', 'senior salesman', '高級業務員', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- INSERT INTO IEOP_ROLE (ID, ROLE_NAME, ROLE_CODE, ROLE_TYPE, ISACTIVE, CREATE_DATE, TENANT_ID, LABEL, DTYPE, REMARK, CREATOR, MODIFY_DATE, REVISER, LABEL_NAME, SYS_ID, TS, DR, ROLE_NAME2, ROLE_NAME3, ROLE_NAME4, ROLE_NAME5, ROLE_NAME6, LABEL_NAME2, LABEL_NAME3, LABEL_NAME4, LABEL_NAME5, LABEL_NAME6) VALUES ('super567ce9517fec4c6aa76d984695dbe0c4', '普通业务员', 'role02', 'user', 'Y', '2018-12-11 14:20:31', 'super', 'buisource', 'WBRole', NULL, 'U001', '2018-12-13 15:15:49', 'U001', '业务员', 'wbalone', '1544685349459', '0', 'general salesman', '普通業務員', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- INSERT INTO `pap_bcr_obj` (`pk_billobj`, `code`, `name`, `pk_parent`, `iscatalog`, `assigntype`, `createdate`, `sysid`, `tenantid`, `name2`, `name3`, `name4`, `name5`, `name6`) VALUES ('super5a87aced-a528-47fa-a48d-1eccfff01e07', 'passenger', 'B3', 'super00001', 'N', NULL, '2018-12-18 16:20:52', 'wbalone', 'super', 'B3', 'B3', NULL, NULL, NULL);
-- INSERT INTO `pap_bcr_obj` (`pk_billobj`, `code`, `name`, `pk_parent`, `iscatalog`, `assigntype`, `createdate`, `sysid`, `tenantid`, `name2`, `name3`, `name4`, `name5`, `name6`) VALUES ('super9c554bb8-6ed4-4c6b-ad52-d652c0585317', 'order', 'B2', 'super00001', 'N', NULL, '2018-12-18 16:20:58', 'wbalone', 'super', 'B2', 'B2', NULL, NULL, NULL);
-- INSERT INTO `pap_bcr_obj` (`pk_billobj`, `code`, `name`, `pk_parent`, `iscatalog`, `assigntype`, `createdate`, `sysid`, `tenantid`, `name2`, `name3`, `name4`, `name5`, `name6`) VALUES ('supere32cee48-ba2e-4aeb-b942-f9794169b2dc', 'iuapd_asval', 'A', 'super00001', 'N', NULL, '2018-12-18 16:21:01', 'wbalone', 'super', 'A', 'A', NULL, NULL, NULL);

-- INSERT INTO PAP_BCR_CANDIDATEPROP (PK, PK_BCR_OBJ, EN_PROP_NAME, DISPLAY_NAME, ELEM_TYPE, MAPPING_ENTITY, CREATE_DATE, DISPLAY_NAME2, DISPLAY_NAME3, DISPLAY_NAME4, DISPLAY_NAME5, DISPLAY_NAME6) VALUES ('superab084588-f34e-4775-b616-fd6c7f070ea3', 'super9c554bb8-6ed4-4c6b-ad52-d652c0585317', 'orderName', '名称', '5', NULL, NULL , 'Name', '名稱', NULL, NULL, NULL);
-- INSERT INTO PAP_BCR_CANDIDATEPROP (PK, PK_BCR_OBJ, EN_PROP_NAME, DISPLAY_NAME, ELEM_TYPE, MAPPING_ENTITY, CREATE_DATE, DISPLAY_NAME2, DISPLAY_NAME3, DISPLAY_NAME4, DISPLAY_NAME5, DISPLAY_NAME6) VALUES ('super0aa2f1e7-6aad-4848-857c-707adf3de812', 'super9c554bb8-6ed4-4c6b-ad52-d652c0585317', 'orderDept', '部门', '6', '222', NULL, 'Department', '部門', NULL, NULL, NULL);

-- INSERT INTO pap_bcr_rulebase (pk_billcodebase, pkbillobj, rulecode, rulename, codemode, iseditable, isautofill, format, isdefault, isused, islenvar, isgetpk, renterid, sysid, createdate, rulename2, rulename3, rulename4, rulename5, rulename6) VALUES ('superaa8d4c80453247a6b50a7caca15d03f4', 'super9c554bb8-6ed4-4c6b-ad52-d652c0585317', 'order', '请购单', 'behCode', 'N', 'N', NULL, 'Y', NULL, 'Y', NULL, 'super', 'wbalone', '2018-12-10 19:56:58', 'Purchase requisition', '請購單', 'null', 'null', 'null');
-- INSERT INTO pap_bcr_rulebase (pk_billcodebase, pkbillobj, rulecode, rulename, codemode, iseditable, isautofill, format, isdefault, isused, islenvar, isgetpk, renterid, sysid, createdate, rulename2, rulename3, rulename4, rulename5, rulename6) VALUES ('superb7617395f5e24d60ae31907570b9aa3a', 'super5a87aced-a528-47fa-a48d-1eccfff01e07', 'passenger', '乘客编码', 'behCode', 'N', 'N', NULL, 'Y', NULL, 'Y', NULL, 'super', 'wbalone', '2018-12-10 19:57:53', 'Passenger code', '乘客編碼', 'null', 'null', 'null');
-- INSERT INTO pap_bcr_rulebase (pk_billcodebase, pkbillobj, rulecode, rulename, codemode, iseditable, isautofill, format, isdefault, isused, islenvar, isgetpk, renterid, sysid, createdate, rulename2, rulename3, rulename4, rulename5, rulename6) VALUES ('superff30ea776c3d4b5b8a743dfb6bb6aafd', 'supere32cee48-ba2e-4aeb-b942-f9794169b2dc', 'iuapd_asval', '员工津贴', 'behCode', 'N', 'N', NULL, 'Y', NULL, 'Y', NULL, 'super', 'wbalone', '2018-12-10 19:56:02', 'Compensate Employees', '員工津貼', 'null', 'null', 'null');

-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super04bdc901910a4bc395302da11f31edb0', 'superaa8d4c80453247a6b50a7caca15d03f4', '1', 'ORDER_', '6', '0', '0', '-1', NULL, NULL, '2018-12-10 19:56:58');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super14a78ff45c324f4288fba80fbb32d993', 'superaa8d4c80453247a6b50a7caca15d03f4', '0', '0', '4', '0', '2', '-1', NULL, NULL, '2018-12-10 19:56:58');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super26d487c5ebd8462f9ad97972c1c0b8c3', 'superff30ea776c3d4b5b8a743dfb6bb6aafd', '1', 'ASVAL_', '6', '0', '0', '-1', NULL, NULL, '2018-12-10 19:56:02');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super53ac2d51b6b343ffbbb855dab322db32', 'superff30ea776c3d4b5b8a743dfb6bb6aafd', '2', NULL, '8', '2', '1', '-1', 'yyyyMMdd', NULL, '2018-12-10 19:56:02');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super55ae5824576b4663bcf5500ded206d92', 'superb7617395f5e24d60ae31907570b9aa3a', '1', 'PASSENGER_', '10', '0', '0', '-1', NULL, NULL, '2018-12-10 19:57:53');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('super597960d66d2c4f83825820f57d310ab0', 'superb7617395f5e24d60ae31907570b9aa3a', '0', '0', '4', '0', '2', '-1', NULL, NULL, '2018-12-10 19:57:53');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('superc4a6985246a4411db1526a18d7146819', 'superaa8d4c80453247a6b50a7caca15d03f4', '2', NULL, '8', '1', '1', '-1', 'yyyyMMdd', NULL, '2018-12-10 19:56:58');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('superc7ca8bbf381841f89b92823578643a0c', 'superb7617395f5e24d60ae31907570b9aa3a', '2', NULL, '8', '2', '1', '-1', 'yyyyMMdd', NULL, '2018-12-10 19:57:53');
-- INSERT INTO pap_bcr_elem (pk_billcodeelem, pk_billcodebase, elemtype, elemvalue, elemlenth, isrefer, eorder, fillstyle, datedisplayformat, fillsign, createdate) VALUES ('superfc01eb1e2581439fb75ffba5c9c40a38', 'superff30ea776c3d4b5b8a743dfb6bb6aafd', '0', '0', '4', '0', '2', '-1', NULL, NULL, '2018-12-10 19:56:02');

-- INSERT INTO ORG_ORGANIZATION (ID, PARENT_ID, CODE, NAME, SHORT_NAME, INNER_CODE, SYS_ID, TENANT_ID, PRINCIPAL, CONTACT, CONTACT_ADDRESS, CREATE_DATE, EFFECTIVE_DATE, DESCRIPTION, TYPE, DEF01, DEF04, DEF17, DEF05, DEF20, DEF10, DEF16, DEF19, DEF12, DEF13, DEF03, DEF09, DEF11, DEF06, DEF15, DEF08, DEF02, DEF07, DEF18, DEF14, TS, DR, CONTACT_PHONE, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('supera4cf0601-51e6-4012-9967-b7a64a4b2d47', '', 'org1', '用友集团', 'yyjt', '0001', 'wbalone', 'super', 'super0dc47840-873a-4ed3-8ae7-c2335a76b385', '', '', '2018-12-07 15:42:51', '2018-12-07 23:42:50', '', 'Organization', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 17:01:07', '0', '', 'yonyou', '用友集團', NULL, NULL, NULL);

-- INSERT INTO org_department (ID, PARENT_ID, ORGANIZATION_ID, INNER_CODE, NAME, CODE, SHORT_NAME, CREATE_DATE, EFFECTIVE_DATE, DESCRIPTION, TENANT_ID, SYS_ID, PRINCIPAL, TYPE, DEF12, DEF16, DEF14, DEF13, DEF04, DEF10, DEF09, DEF05, DEF18, DEF15, DEF08, DEF19, DEF17, DEF11, DEF01, DEF20, DEF02, DEF07, DEF06, DEF03, TS, DR, NAME2, NAME3, NAME4, NAME5, NAME6, SHORT_NAME2, SHORT_NAME3, SHORT_NAME4, SHORT_NAME5, SHORT_NAME6) VALUES ('super0ebbb6d8-250a-4d1d-a019-7ae951629a2c', NULL, 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', '0004', '生产处', 'dept2', 'scc', '2018-12-07 15:47:17', '2018-12-07 15:47:20', '', 'super', 'wbalone', '', 'Dept', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 17:01:31', '0', 'scc', '生產處', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- INSERT INTO org_department (ID, PARENT_ID, ORGANIZATION_ID, INNER_CODE, NAME, CODE, SHORT_NAME, CREATE_DATE, EFFECTIVE_DATE, DESCRIPTION, TENANT_ID, SYS_ID, PRINCIPAL, TYPE, DEF12, DEF16, DEF14, DEF13, DEF04, DEF10, DEF09, DEF05, DEF18, DEF15, DEF08, DEF19, DEF17, DEF11, DEF01, DEF20, DEF02, DEF07, DEF06, DEF03, TS, DR, NAME2, NAME3, NAME4, NAME5, NAME6, SHORT_NAME2, SHORT_NAME3, SHORT_NAME4, SHORT_NAME5, SHORT_NAME6) VALUES ('super55b7fff1-6579-4ca9-92b7-3271d288b9f3', 'super95b60f35-ed0b-454e-b948-fb45ae30b911', 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', '00010003', '财务二科', 'dept1_2', 'cwek', '2018-12-07 15:45:13', '2018-12-07 15:45:16', '', 'super', 'wbalone', '', 'Dept', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 17:02:01', '0', 'cwsecond', '財務二科', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- INSERT INTO org_department (ID, PARENT_ID, ORGANIZATION_ID, INNER_CODE, NAME, CODE, SHORT_NAME, CREATE_DATE, EFFECTIVE_DATE, DESCRIPTION, TENANT_ID, SYS_ID, PRINCIPAL, TYPE, DEF12, DEF16, DEF14, DEF13, DEF04, DEF10, DEF09, DEF05, DEF18, DEF15, DEF08, DEF19, DEF17, DEF11, DEF01, DEF20, DEF02, DEF07, DEF06, DEF03, TS, DR, NAME2, NAME3, NAME4, NAME5, NAME6, SHORT_NAME2, SHORT_NAME3, SHORT_NAME4, SHORT_NAME5, SHORT_NAME6) VALUES ('super95b60f35-ed0b-454e-b948-fb45ae30b911', NULL, 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', '0001', '财务处', 'dept1', 'cwc', '2018-12-07 15:44:32', '2018-12-07 15:44:35', '', 'super', 'wbalone', '', 'Dept', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 17:01:39', '0', 'cwc', '財務處', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- INSERT INTO org_department (ID, PARENT_ID, ORGANIZATION_ID, INNER_CODE, NAME, CODE, SHORT_NAME, CREATE_DATE, EFFECTIVE_DATE, DESCRIPTION, TENANT_ID, SYS_ID, PRINCIPAL, TYPE, DEF12, DEF16, DEF14, DEF13, DEF04, DEF10, DEF09, DEF05, DEF18, DEF15, DEF08, DEF19, DEF17, DEF11, DEF01, DEF20, DEF02, DEF07, DEF06, DEF03, TS, DR, NAME2, NAME3, NAME4, NAME5, NAME6, SHORT_NAME2, SHORT_NAME3, SHORT_NAME4, SHORT_NAME5, SHORT_NAME6) VALUES ('super9711d912-3184-4063-90c5-1facc727813c', 'super95b60f35-ed0b-454e-b948-fb45ae30b911', 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', '00010002', '财务一科', 'dept1_1', 'cwyk', '2018-12-07 15:44:52', '2018-12-07 15:44:54', '', 'super', 'wbalone', '', 'Dept', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 17:02:35', '0', 'cwfirst', '財務一科', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- INSERT INTO bd_position (id, code, name, innercode, creator, creationtime, modifier, modifiedtime, sysid, enable, ts, dr, org_id, dept_id, job_id, jobtype_id, maxrank_id, minrank_id, suporior, maxage, minage, professional, degree, reqedu, reqsex, reqworktime, reqexp, reqcert, duties, memo, loc_id, bu_id, jobgrade_id, establishdate, parentid, objid, businessid, synchts, create_time, create_user, last_modified, last_modify_user, tenant_id, name2, name3, name4, name5, name6) VALUES ('super6c705e752cf54739afd1b5c327b5dfd3', 'station1_1_1', '会计', NULL, NULL, NULL, NULL, NULL, NULL, '1', '2018-12-14 17:04:06', '0', 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', 'super9711d912-3184-4063-90c5-1facc727813c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 09:04:36', 'U001', 'super', 'accountant', '會計', NULL, NULL, NULL);
-- INSERT INTO bd_position (id, code, name, innercode, creator, creationtime, modifier, modifiedtime, sysid, enable, ts, dr, org_id, dept_id, job_id, jobtype_id, maxrank_id, minrank_id, suporior, maxage, minage, professional, degree, reqedu, reqsex, reqworktime, reqexp, reqcert, duties, memo, loc_id, bu_id, jobgrade_id, establishdate, parentid, objid, businessid, synchts, create_time, create_user, last_modified, last_modify_user, tenant_id, name2, name3, name4, name5, name6) VALUES ('super804774adb9a84dd1a32a0d475da4c5b7', 'station1', '处长', NULL, NULL, NULL, NULL, NULL, NULL, '1', '2018-12-14 17:03:35', '0', 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', 'super95b60f35-ed0b-454e-b948-fb45ae30b911', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 09:04:02', 'U001', 'super', 'section chief', '處長', NULL, NULL, NULL);
-- INSERT INTO bd_position (id, code, name, innercode, creator, creationtime, modifier, modifiedtime, sysid, enable, ts, dr, org_id, dept_id, job_id, jobtype_id, maxrank_id, minrank_id, suporior, maxage, minage, professional, degree, reqedu, reqsex, reqworktime, reqexp, reqcert, duties, memo, loc_id, bu_id, jobgrade_id, establishdate, parentid, objid, businessid, synchts, create_time, create_user, last_modified, last_modify_user, tenant_id, name2, name3, name4, name5, name6) VALUES ('superd04dd724a3dc43f3a039d055a6c9bbdd', 'station1_1', '科长', NULL, NULL, NULL, NULL, NULL, NULL, '1', '2018-12-14 17:02:49', '0', 'supera4cf0601-51e6-4012-9967-b7a64a4b2d47', 'super9711d912-3184-4063-90c5-1facc727813c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-14 09:03:26', 'U001', 'super', 'Section Chief', '科長', NULL, NULL, NULL);


-- 经典示例自有的预制数据 start ------------------------------------------------------
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00001', '测试1', '2', '0', '', '', '2018-11-06 08:40:03 874', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00002', '测试2', '2', '0', '', '', '2018-11-06 08:40:03 875', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00003', '测试3', '2', '0', '', '', '2018-11-06 08:40:03 876', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00004', '测试4', '2', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00005', '测试5', '2', '0', '', '', '2018-12-11 09:39:36 428', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:36 428', '0', '0', 'super', '0005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00006', '测试6', '1', '0', '', '', '2018-12-11 09:37:42 174', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:37:42 175', '0', '0', 'super', '0006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00007', '测试7', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00008', '测试8', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00009', '测试9', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00010', '测试10', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00011', '测试11', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0011');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00012', '测试12', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0012');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00013', '测试13', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0013');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00014', '测试14', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0014');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00015', '测试15', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0015');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00016', '测试16', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0016');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00017', '测试17', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0017');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00018', '测试18', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0018');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00019', '测试19', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0019');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00020', '测试20', '1', '0', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0020');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00101', '测试1_1', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00102', '测试1_2', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00103', '测试1_3', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00104', '测试1_4', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00105', '测试1_5', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00106', '测试1_6', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00107', '测试1_7', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00108', '测试1_8', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00109', '测试1_9', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00110', '测试1_10', '1', 'supera7fd55cb0bfd4a28a560a29c65b00001', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00010010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00181', '测试2_1', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00182', '测试2_2', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00183', '测试2_3', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00184', '测试2_4', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00185', '测试2_5', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00186', '测试2_6', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00187', '测试2_7', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00188', '测试2_8', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00189', '测试2_9', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00190', '测试2_10', '1', 'supera7fd55cb0bfd4a28a560a29c65b00002', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00020010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00261', '测试3_1', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00262', '测试3_2', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00263', '测试3_3', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00264', '测试3_4', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00265', '测试3_5', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00266', '测试3_6', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00267', '测试3_7', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00268', '测试3_8', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00269', '测试3_9', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00270', '测试3_10', '1', 'supera7fd55cb0bfd4a28a560a29c65b00003', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00030010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00341', '测试4_1', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00342', '测试4_2', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00343', '测试4_3', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00344', '测试4_4', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00345', '测试4_5', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00346', '测试4_6', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00347', '测试4_7', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00348', '测试4_8', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00349', '测试4_9', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00350', '测试4_10', '1', 'supera7fd55cb0bfd4a28a560a29c65b00004', '', '', '2018-11-06 08:40:03 877', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '00040010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00421', '测试5_1', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:34:25 081', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:34:25 082', '0', '0', 'super', '00050001');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00422', '测试5_2', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:39:35 044', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:35 044', '0', '0', 'super', '00050002');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00423', '测试5_3', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:39:36 442', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:35 061', '0', '0', 'super', '00050003');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00424', '测试5_4', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:38:49 239', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:38:47 051', '0', '0', 'super', '00050004');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00425', '测试5_5', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:39:36 439', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:36 439', '0', '0', 'super', '00050005');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00426', '测试5_6', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:39:11 121', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:11 121', '0', '0', 'super', '00050006');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00427', '测试5_7', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:39:11 138', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:39:08 827', '0', '0', 'super', '00050007');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00428', '测试5_8', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:37:27 124', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:37:27 124', '0', '0', 'super', '00050008');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00429', '测试5_9', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:37:44 726', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:37:44 727', '0', '0', 'super', '00050009');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65b00430', '测试5_10', '1', 'supera7fd55cb0bfd4a28a560a29c65b00005', '', '', '2018-12-11 09:37:44 746', 'super8fc4556df56449c39922ac2d67cfbde6', '2018-12-11 17:37:42 189', '0', '0', 'super', '00050010');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6701', '测试测试1', '1', '0', '', '', '2018-11-06 08:40:03 874', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 910', '0', '0', 'super', '0101');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6702', '测试测试2', '2', '0', '', '', '2018-11-06 05:42:54 490', '', '2018-11-06 13:42:54 495', '0', '0', 'super', '0102');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6703', '测试测试3', '2', '0', '', '', '2018-11-06 08:40:03 189', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:40:03 220', '0', '0', 'super', '0103');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6704', '测试测试2_1', '1', 'supera7fd55cb0bfd4a28a560a29c65bf6702', '', '', '2018-11-05 07:54:57 395', '', '2018-11-05 15:54:57 423', '0', '0', 'super', '01020101');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6705', '测试测试2_2', '2', 'supera7fd55cb0bfd4a28a560a29c65bf6702', '', '', '2018-11-06 06:28:14 282', '', '2018-11-06 14:28:14 327', '0', '0', 'super', '01020102');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6706', '测试测试3_1', '1', 'supera7fd55cb0bfd4a28a560a29c65bf6703', '', '', '2018-11-06 08:40:04 163', 'supere4664c3af5384084926d54e0d9b740d4', '2018-11-06 16:39:50 565', '0', '0', 'super', '01030101');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6707', '测试测试2_2_1', '1', 'supera7fd55cb0bfd4a28a560a29c65bf6705', '', '', '2018-10-26 11:31:29 217', '', '2018-10-26 19:27:12 342', '0', '0', 'super', '010201020101');
INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('supera7fd55cb0bfd4a28a560a29c65bf6708', '测试测试2_2_2', '1', 'supera7fd55cb0bfd4a28a560a29c65bf6705', '', '', '2018-11-05 07:12:13 862', '', '2018-11-05 15:12:06 523', '0', '0', 'super', '010201020102');
-- INSERT INTO IUAPD_TREELIST (ID, NAME, IS_SON, PARENTID, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID, CODE) VALUES ('superf18ee4d7c42b436b8da1379aa473d9f8', '555', '1', '0', '2018-11-26 20:35:09 049', 'U001', '2018-11-27 03:14:33 700', 'U001', '2018-11-27 11:14:33 709', '0', '0', 'super', '0105');

INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel1', 'T1', '技术','technique','技術','','','', '1', '初级','primary','初級','','','', '', '', '', '', '', '1', '0', 'super');
INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel2', 'M1', '管理','management','管理','','','', '1', '初级','primary','初級','','','', '', '', '', '', '', '1', '0', 'super');
INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel3', 'T2', '技术','technique','技術','','','', '2', '中级','intermediate','中級','','','', '', '', '', '', '', '1', '0', 'super');
INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel4', 'M2', '管理','management','管理','','','', '2', '中级','intermediate','中級','','','', '', '', '', '', '', '1', '0', 'super');
INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel5', 'T3', '技术','technique','技術','','','', '3', '高级','senior','高級','','','',  '', '', '', '', '', '1', '0', 'super');
INSERT INTO IUAPD_RANKS (ID, CODE, TYPE,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,GRADE, POST_LEVEL,POST_LEVEL2,POST_LEVEL3,POST_LEVEL4,POST_LEVEL5,POST_LEVEL6, CREATE_TIME, CREATE_USER, LAST_MODIFIED, LAST_MODIFY_USER, TS, DR, BPM_STATE, TENANT_ID) VALUES ('superlevel6', 'M3', '管理','management','管理','','','', '3', '高级','senior','高級','','','',  '', '', '', '', '', '1', '0', 'super');
-- 经典示例自有预制数据 end ---------------------------------------------------------
-- 经典示例 涉及的iuap平台预制数据和示例预制数据 end ---------------------------------------------------------

-- 参照示例
INSERT INTO WB_APP_APPS VALUES ('super27228e888fcfec75f8fe57b7', '参照示例', '2', 'super6c173e474f3742a1b70960f4e1cca4df', 'super646966f7aa5d4b338b9897afc1629df6', '/iuap-pap-demo-fe/ref-demo#/', null, null, 'pap pap-bujuguanli', null, 'refdemo', null, 'super', 'url', '2', 'wbalone', null, 'apparea', null, 'U001', null, null, 'RefDemo', '參照示例', null, null, null);
INSERT INTO WB_LABEL_RELATION VALUES ('super27228e888fcfec75f8fe57b7', 'syssource', 'refdemo', null, 'super', 'wbalone', null, 'super27228e888fcfec75f8fe57b7', 'app');
INSERT INTO WB_LABEL_RELATION VALUES ('super27228e888fcfec75f8fe57b8', 'mgrsource', 'refdemo', null, 'super', 'wbalone', null, 'super27228e888fcfec75f8fe57b7', 'app');
INSERT INTO IEOP_ROLE_PERMISSION  (ID, ROLE_ID, ROLE_CODE, PERMISSION_ID, PERMISSION_CODE, PERMISSION_TYPE, TENANT_ID, SYS_ID) VALUES ('super27228e888fcfec75f8fe57b7', 'superR001', 'admin', 'super27228e888fcfec75f8fe57b7', 'refdemo', '1', 'super', 'wbalone');
INSERT INTO WB_APP_MENU (ID, FUNC_ID, ICON, ISENABLE, ISVISIBLE, IS_VIRTUAL_NODE, PARENT_ID, CLASSIFY, LAYOUT_ID, SORT, CREATE_TIME, NAME, TENANT_ID, VERSION, LABEL, TS, DR, OPENVIEW, NAME2, NAME3, NAME4, NAME5, NAME6) VALUES ('supera917a3c1bf80422ab2f17ebe61357cde', 'refdemo', ' iconfont icon-appicon ', 'Y', 'Y', 'N', 'supere238812395b647969d77be13757abb1e', NULL, 'refdemo', '7', NULL, '参照示例', 'super', '0', 'common', NULL, NULL, 'curnpage', 'refdemo', '參照示例', '', '', '');

GO